Toufong Vang
Toufong Vang
Reactions
-
Re: Previous, Current, and Next Weeks with New Year
You are correct, @Cesar Perez , the expression is counting the days instead of the actual week number of the year. To do that, we'll need to use the WEEKNUMBER() function. The expression for the appr…1 · -
Re: COUNTIF(DATE("Reference another Sheet Column") Date=Year To Date ) ***HELP***
Hi, @J Smith, The formula below returns the count of rows from the other sheet that are between Jan. 1st of the current year and today. = COUNTIF({Column_from_other_sheet_containing_date_value}, AND(…1 · -
Re: WEEKNUMBER formula
Hi, @holli.nunn, modify your formula to... =(YEAR([SD End]@row) - YEAR([SD Start]@row)) * 52 + WEEKNUMBER([SD End]@row) - WEEKNUMBER([SD Start]@row) You needed to account for start-end dates that spa…1 · -
Re: Is there a way to stop percentage from converting in a formula?
@sharkasits, you don't necessarily need to ask the user if the value they entered is a string (e.g., 20.25%) or a numeric value (e..g., 0.2025). If the values in the column Value contains a mix of st…1 · -
Re: How can I get the last matching value on Smartsheet?
If "last matching value" is the largest value in Amount, then... =MAX(COLLECT(Amount:Amount, [Group Name]:[Group Name], =[Group Name]@row)) However, if "last matching value" is th…2 ·
